Share via

Migrating On-prem Sql DB to Azure Managed Sql Instance

pdsqsql 391 Reputation points
2024-05-14T22:06:14.8033333+00:00

Hello,

I have created recently Azure Managed Instance and looking some expert guidance as I need to restore on-prem Database first for testing but my database is in simple recovery mode as it's non-prod DB.

Do I need to change recovery model to FULL then take a FULL backup and Restore to the Azure Managed Instance?

Please keep in mnd that I need to leave the database in on-prem as it is as applications are connecting and using but need to take the backup and restore it for testing first before I di actual cut over.

I am also looking other options to migrate/restore the On-prem Database to Azure Sql Managed Instance.as Data Migration Assistant is not supporting to migrate the database to Azure Managed Instance.

Is it Azure Data Studio has Offline database migration option keep on-prem database and just restore to Azure Managed Instance only so we can have both the places DB?

Anyone has step by step proper guidelines to create the Managed Instance and restore/migrate the DB to Managed Instance although I have created but looking proper steps so I can assign the task to our Security, Networking and operation team as we I don't have much access to set Managed Instance from starting to end which contains to create Resource Group, set up Networking (NSG, Peering, Firewall Rules for inbound/Outbound rules etc).

This is totally new for me and looking some proper steps although I have created one test instance.

Thanks for your help!

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 33,001 Reputation points MVP
    2024-05-15T00:48:36.2833333+00:00

    You can use Azure Data Studio with the Azure SQL Extension for that migration scenario. See a tutorial here. The Azure SQL Migration extension for Azure Data Studio uses existing database backup files for the migration. So Azure Data Studio does not impact the production database on-premises while doing the migration.

    If that does not work for you, you can also use the familiar method of backup and restore as explained here. Another useful video about restoring backups on Azure SQL Managed instance can be found here. Azure SQL Database requires full database backups regardless of the recovery model of the database (simple or full).